Skip to main content

ValuesIN

1. Description​

The ValuesIN Derivation Type is used to ensure that values in specified columns belong to the allowed set.

2. Screen Configuration​

values_in_image

For the column names provided, it checks if the values of that column belongs to one of the value provided in values section of required fields.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String".
  • dervation
    • derivation_type: The calculation type used to derive this output field, which for concat is "CONCAT".
    • req_fields
      • col_name: Field names from the input metadata.
      • values: Values that should be present (Comma separated).